I created a view in my test database let's call it view1 . I then created a view called view2 that depends on view1. when I ran sp_depends on view1 it did not show view2 and when I dropped view1 it did not drop view2 . Does anybody know why ? TIA